INSERT INTO locations
	VALUES (seq_locations.NEXTVAL, 'Head office');
INSERT INTO locations
	VALUES (seq_locations.NEXTVAL, 'Area A');
INSERT INTO locations
	VALUES (seq_locations.NEXTVAL, 'Area B');

INSERT INTO equipment_types
	VALUES (seq_equip_types.NEXTVAL, 'Hub');
INSERT INTO equipment_types
	VALUES (seq_equip_types.NEXTVAL, 'Switch');

INSERT INTO equipments
	VALUES (seq_equip.NEXTVAL, 'Hub_10-8', 1, 10, 8);
INSERT INTO equipments
	VALUES (seq_equip.NEXTVAL, 'Switch_10-16', 1, 10, 16);
INSERT INTO equipments
	VALUES (seq_equip.NEXTVAL, 'Switch_100-16', 1, 100, 16);
INSERT INTO equipments
	VALUES (seq_equip.NEXTVAL, 'Switch_100-32', 1, 100, 32);

INSERT INTO actions
	VALUES (seq_actions.NEXTVAL, 'Receipt');
INSERT INTO actions
	VALUES (seq_actions.NEXTVAL, 'Mounting');
INSERT INTO actions
	VALUES (seq_actions.NEXTVAL, 'Write-off');

INSERT INTO journal
	VALUES (TO_DATE('25/7/01', 'DD/MM/YY'), 1, 20, 1, 1);
INSERT INTO journal
	VALUES (TO_DATE('26/7/01', 'DD/MM/YY'), 2, 4, 1, 1);
INSERT INTO journal
	VALUES (TO_DATE('14/8/01', 'DD/MM/YY'), 1, 12, 1, 1);

INSERT INTO journal
	VALUES (TO_DATE('21/8/01', 'DD/MM/YY'), 1, 8, 2, 2);
INSERT INTO journal
	VALUES (TO_DATE('23/8/01', 'DD/MM/YY'), 1, 3, 2, 3);
INSERT INTO journal
	VALUES (TO_DATE('1/9/01', 'DD/MM/YY'), 2, 3, 2, 2);
	
INSERT INTO journal
	VALUES (TO_DATE('3/9/01', 'DD/MM/YY'), 4, 5, 1, 1);
	
INSERT INTO journal
	VALUES (TO_DATE('7/9/01', 'DD/MM/YY'), 4, 5, 2, 1);
INSERT INTO journal
	VALUES (TO_DATE('14/9/01', 'DD/MM/YY'), 1, 5, 2, 2);
	
INSERT INTO journal
	VALUES (TO_DATE('21/9/01', 'DD/MM/YY'), 3, 12, 1, 1);	
	
INSERT INTO journal
	VALUES (TO_DATE('25/9/01', 'DD/MM/YY'), 1, 8, 2, 2);
INSERT INTO journal
	VALUES (TO_DATE('2/10/01', 'DD/MM/YY'), 2, 1, 2, 3);
INSERT INTO journal
	VALUES (TO_DATE('8/10/01', 'DD/MM/YY'), 1, 4, 2, 3);
INSERT INTO journal
	VALUES (TO_DATE('10/10/01', 'DD/MM/YY'), 3, 3, 2, 3);
	
INSERT INTO journal
	VALUES (TO_DATE('12/10/01', 'DD/MM/YY'), 4, 1, 1, 1);
	
INSERT INTO journal
	VALUES (TO_DATE('14/10/01', 'DD/MM/YY'), 3, 4, 2, 2);

COMMIT;